UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W97XZ8XN+p57SS9SWMiuUCKSVYutx+6BIl6wZw6FzW4='
WHERE
key_id = '31b83466e0407b50b58c5d154baad44037b7f8a61f6ef5be052e3b1e5ba53333'
AND (
token = 'W97XZ8XN+p57SS9SWMiuUCKSVYutx+6BIl6wZw6FzW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)