UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gxjVKh/Mc9DXfbJNyHlwujsXpYXNog0X/ZHU0Y7rTWc='
WHERE
key_id = 'adddc1626c04897a89fef933101b75dc58e3952746f10d87e49739b4cd8ef72d'
AND (
token = 'gxjVKh/Mc9DXfbJNyHlwujsXpYXNog0X/ZHU0Y7rTWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)