UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7mT8pPhzTwtfLRee4DzDH8lsn+yTOG3QN38N0mVd+t8='
WHERE
key_id = '552b3d015ceeb90dd510193ff72086465f6a77ce580ecc528296881e396ddf6d'
AND (
token = '7mT8pPhzTwtfLRee4DzDH8lsn+yTOG3QN38N0mVd+t8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)