UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fpLv3LxoySMeU2yJzZwHCIi/tLkvrldTE/dt9rHUDrE='
WHERE
key_id = 'e1b1cba5ca1e96bcbe466166ea209ea263150b5c80fff3d569564989c2c67cfb'
AND (
token = 'fpLv3LxoySMeU2yJzZwHCIi/tLkvrldTE/dt9rHUDrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)