UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ptx+OIrF73SLHO/poc1L6zzgtiilEO0fJuIzLCNdTX8='
WHERE
key_id = '5108877b0ef7913ba5fabff646bee475612ba0f4bd7fb9a462801944d4771d13'
AND (
token = 'ptx+OIrF73SLHO/poc1L6zzgtiilEO0fJuIzLCNdTX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)