UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zTs+kzqjPCSeCh+cM5naOoDbXQeo0AbFnqE12AHfRIM='
WHERE
key_id = '187d7b075b2877203c8f1129c22ea7bb8d2d860db902565b010020d6242f7c5d'
AND (
token = 'zTs+kzqjPCSeCh+cM5naOoDbXQeo0AbFnqE12AHfRIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)