UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2hP3OIJLIv+eLfPK4DVZDPR9HiXAJhaoZMpEC5WWfqk='
WHERE
key_id = '2a97fdb9b78c449704ae90fdae9a2ccdca0b0043d1e6a06448d594096b11f178'
AND (
token = '2hP3OIJLIv+eLfPK4DVZDPR9HiXAJhaoZMpEC5WWfqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)