UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q/NJP8A6KKicnDTV5i7Drt2Zy7kwcSFosWwZwY4F7V0='
WHERE
key_id = 'acbc1d10ac367baafbd98f51afff649f629ba6f471597fbe952443d63b01c467'
AND (
token = 'q/NJP8A6KKicnDTV5i7Drt2Zy7kwcSFosWwZwY4F7V0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)