UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QmUnc8uQnr2HO+ARDzoZvRVxJjCruu3/33VYWlSwroE='
WHERE
key_id = '18c2307be48e93e763f1d903c4ec544c6b9ab0c8abbf84f59bc9246574367779'
AND (
token = 'QmUnc8uQnr2HO+ARDzoZvRVxJjCruu3/33VYWlSwroE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)