UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nXdU0pakjkRzgVn8smUu0VcUnhbrSWzjyUJc2BEKwFI='
WHERE
key_id = 'd1a70431b12c02c54c08dc04b04aebbb0f32cddee1531f77e42d8d32651b1dfd'
AND (
token = 'nXdU0pakjkRzgVn8smUu0VcUnhbrSWzjyUJc2BEKwFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)