UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ow9pD7iJ7QHOAnB2z8L0E7WkjcNSd3JRf/IsxZqfRhA='
WHERE
key_id = '7f227c61b98b717c580d2a1bf5b9abc43537f4a7e6f1fbfbb9bb8b171f053b39'
AND (
token = 'ow9pD7iJ7QHOAnB2z8L0E7WkjcNSd3JRf/IsxZqfRhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)