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