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