UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lf9OA7OJFgbbQ0DmJxan+e79tRBflr3UTV8XgABHmP8='
WHERE
key_id = '0ce678231b0f3c677ce072a6cff9dcc68c4f7ef1581bf9585d2060fb23fd4a71'
AND (
token = 'lf9OA7OJFgbbQ0DmJxan+e79tRBflr3UTV8XgABHmP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)