UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's0XeAUFR0BEd8EBvzXEGvktVxSYEbhAsXdulntX4Fuk='
WHERE
key_id = '816ef56c29f912f779c561635b63e145a87adfe65dbb18bd7b2d8040ac4fb5ab'
AND (
token = 's0XeAUFR0BEd8EBvzXEGvktVxSYEbhAsXdulntX4Fuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)