UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rc4+rXj7o363Gu3mFxnktM+S88MPCQ6R9Thrn3Y9L6U=' 
WHERE 
  key_id = '846bcf8f132df51a686fdad0360b1736592bf26fb35dc9d0f6d153a7102e709e' 
  AND (
    token = 'rc4+rXj7o363Gu3mFxnktM+S88MPCQ6R9Thrn3Y9L6U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022