UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rcxv8CpWomic+Vtd5vgKI3K4ipMI1U/oiUrs/CqZhMA=' 
WHERE 
  key_id = '8e35b55b4f1ac5d78602bf2814459ec3a77942570982c5e372c8969f1fff8cd8' 
  AND (
    token = 'rcxv8CpWomic+Vtd5vgKI3K4ipMI1U/oiUrs/CqZhMA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034