UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WPLj2WYmwnaqZ7PS7+ufV4+1kdGdW+1CmHzS8D9w7ag='
WHERE
key_id = '4c34b1de3adf13e37fca2443dd5daef66fc1692e78167a2e71a14a6259bfe450'
AND (
token = 'WPLj2WYmwnaqZ7PS7+ufV4+1kdGdW+1CmHzS8D9w7ag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)