UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+DVYDuGoJxG8H6injNFFe7BtFPxr4rwZrCOQ7s2+Vmk=' 
WHERE 
  key_id = '36176342d74a828907e0159833bd4c6ff1ec0a031dc6736b1b47d5c989add842' 
  AND (
    token = '+DVYDuGoJxG8H6injNFFe7BtFPxr4rwZrCOQ7s2+Vmk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046