UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oV0VRWzqYa1W2pmcJIpp2+J1tGBhTX0u5EojCbIMmQ0='
WHERE
key_id = '78d6380862fe36dc0ef161355c4a1ef6627b89f2400c313b121d3e9e72802f1c'
AND (
token = 'oV0VRWzqYa1W2pmcJIpp2+J1tGBhTX0u5EojCbIMmQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)