UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jv9avg75hBI1xCHOc/BGJ7Zefb0x8V62hpG+aGO0BGY='
WHERE
key_id = '378b50798590c016add452d760dbdd08b1803956e44f7b06afd70714d8a9b95a'
AND (
token = 'jv9avg75hBI1xCHOc/BGJ7Zefb0x8V62hpG+aGO0BGY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)