UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yOfPnzhIpzScXVSfZMqWYBAzSdfu7/6FcfnNAsTqyyY='
WHERE
key_id = '869d8d7ace5dbcf9b224a70acb70a88bf0d17c502acad4fd23d6f639a77fa3e6'
AND (
token = 'yOfPnzhIpzScXVSfZMqWYBAzSdfu7/6FcfnNAsTqyyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)