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