UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gpYYqMoJod9XZ8B5bdp3XBlEU9O0ETdC12+G/AUS/Ss='
WHERE
key_id = '5b46eaa11be884e80217f15c95c6aa31f101a4a48e615d03c23afb9bf0905607'
AND (
token = 'gpYYqMoJod9XZ8B5bdp3XBlEU9O0ETdC12+G/AUS/Ss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)