UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j8emIiyhhXDZkeiGmV0wjmBH0F7j50OMaoIv82ABPio='
WHERE
key_id = '018bb7ef68e59348fc5bfa48f24ade8ef7a5784fffcf4f978aa3387b6b298c0a'
AND (
token = 'j8emIiyhhXDZkeiGmV0wjmBH0F7j50OMaoIv82ABPio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)