UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iqIijt7tBtFdpNd2YX4rTfkBYWVwDgI1Hi4w80GqoLY='
WHERE
key_id = '294afbe7c94cc838db9a3526105858dc4afdadd156209a93accc1caf08cce9ae'
AND (
token = 'iqIijt7tBtFdpNd2YX4rTfkBYWVwDgI1Hi4w80GqoLY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)