UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ge6zgDuOZ5TCOwofOsWZh5Ognin4m1woRpxsFBswpwA='
WHERE
key_id = '0af9b0da49c408b57a1641f2c481ab83d997a91c2d29f71a95993766b5a8d0b2'
AND (
token = 'ge6zgDuOZ5TCOwofOsWZh5Ognin4m1woRpxsFBswpwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)