UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgYnOnEU7eOMXIq/CMfFa8DyNsU4GTTHq7/Qx4VoTrk='
WHERE
key_id = 'd16e36e31ad7fc48fbf51f14777f57804a84e79df256be2c425c09ae70dfce94'
AND (
token = 'BgYnOnEU7eOMXIq/CMfFa8DyNsU4GTTHq7/Qx4VoTrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)