UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p7mR/ybzx3sFE+xe+vVr6+INcMX49d6leOq61yd/5v8='
WHERE
key_id = '05aa24a377bb0232ead848c76b9bd5355609a3290a7096ab3d6c020a7839199a'
AND (
token = 'p7mR/ybzx3sFE+xe+vVr6+INcMX49d6leOq61yd/5v8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)