UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mXX3hQ9tM80nDeuN+h6H0itNnXzRe5oXvEEHNVimriE='
WHERE
key_id = '0ad4093c10f243bf294d15a013faf76d362ce401b764e585435645ad4d01165e'
AND (
token = 'mXX3hQ9tM80nDeuN+h6H0itNnXzRe5oXvEEHNVimriE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)