UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9o2pWY7DdHVKoZRA7aDsCxKIBE1OArCeuInO7p0aVWs='
WHERE
key_id = 'bc513c54b9a974e9320ff5ae4cc18574e806d88b68140415646a3c220bfeda6e'
AND (
token = '9o2pWY7DdHVKoZRA7aDsCxKIBE1OArCeuInO7p0aVWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)